Sites Outliers Report

Dataset statistics

Number of variables	14
Number of observations	24232
Missing cells	25292
Missing cells (%)	7.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 MiB
Average record size in memory	112.0 B

Variable types

Numeric	12
DateTime	1
Categorical	1

Alerts

`targets` has constant value "1"	Constant
`MP1 FLOW1 (l/s)` is highly correlated with `MP1 UNIDEPTH (mm)` and 2 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 1 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 1 other fields	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)`	High correlation
`Daily Cumulative Rainfall (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 WATERTEMP_1 (°C)` is highly correlated with `month`	High correlation
`month` is highly correlated with `MP1 WATERTEMP_1 (°C)`	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `Raw Average Velocity (m/s)`	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `MP1 UpDEPTH_1 (mm)`	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `MP1 UNIDEPTH (mm)`	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `MP1 FLOW1 (l/s)`	High correlation
`df_index` is highly correlated with `MP1 WATERTEMP_1 (°C)` and 3 other fields	High correlation
`Daily Cumulative Rainfall (mm)` is highly correlated with `MP1 FLOW1 (l/s)` and 3 other fields	High correlation
`MP1 FLOW1 (l/s)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 PDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UNIDEPTH (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 UpDEPTH_1 (mm)` is highly correlated with `Daily Cumulative Rainfall (mm)` and 3 other fields	High correlation
`MP1 WATERTEMP_1 (°C)` is highly correlated with `df_index` and 1 other fields	High correlation
`Raw Average Velocity (m/s)` is highly correlated with `df_index`	High correlation
`day` is highly correlated with `df_index` and 1 other fields	High correlation
`month` is highly correlated with `df_index` and 2 other fields	High correlation
`MP1 FLOW1 (l/s)` has 4213 (17.4%) missing values	Missing
`MP1 PDEPTH_1 (mm)` has 4213 (17.4%) missing values	Missing
`MP1 UNIDEPTH (mm)` has 4213 (17.4%) missing values	Missing
`MP1 UpDEPTH_1 (mm)` has 4213 (17.4%) missing values	Missing
`MP1 WATERTEMP_1 (°C)` has 4213 (17.4%) missing values	Missing
`Raw Average Velocity (m/s)` has 4213 (17.4%) missing values	Missing
`Final Rainfall (mm)` is highly skewed (γ1 = 24.17215341)	Skewed
`df_index` has unique values	Unique
`date` has unique values	Unique
`Daily Cumulative Rainfall (mm)` has 15969 (65.9%) zeros	Zeros
`Final Rainfall (mm)` has 23303 (96.2%) zeros	Zeros
`MP1 FLOW1 (l/s)` has 4243 (17.5%) zeros	Zeros
`Raw Average Velocity (m/s)` has 4243 (17.5%) zeros	Zeros
`hour` has 1078 (4.4%) zeros	Zeros

Reproduction

Analysis started	2021-12-13 10:15:47.299179
Analysis finished	2021-12-13 10:16:00.083424
Duration	12.78 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	24232
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	138161.0091

Minimum	16
Maximum	254311
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	16
5-th percentile	39074.55
Q1	113917.75
median	138838.5
Q3	144896.25
95-th percentile	224423.45
Maximum	254311
Range	254295
Interquartile range (IQR)	30978.5

Descriptive statistics

Standard deviation	52066.63521
Coefficient of variation (CV)	0.3768547693
Kurtosis	0.02691864444
Mean	138161.0091
Median Absolute Deviation (MAD)	24243
Skewness	0.1098546929
Sum	3347917572
Variance	2710934502
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1	< 0.1%
142873	1	< 0.1%
142882	1	< 0.1%
142881	1	< 0.1%
142880	1	< 0.1%
142879	1	< 0.1%
142878	1	< 0.1%
142877	1	< 0.1%
142876	1	< 0.1%
142875	1	< 0.1%
Other values (24222)	24222	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
21	1	< 0.1%
22	1	< 0.1%
23	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
254311	1	< 0.1%
254310	1	< 0.1%
254309	1	< 0.1%
254308	1	< 0.1%
254307	1	< 0.1%
254306	1	< 0.1%
254305	1	< 0.1%
254304	1	< 0.1%
254303	1	< 0.1%
254302	1	< 0.1%

Daily Cumulative Rainfall (mm)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	267
Distinct (%)	1.1%
Missing	7
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.204293087

Minimum	0
Maximum	68.5
Zeros	15969
Zeros (%)	65.9%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.4
95-th percentile	6.4
Maximum	68.5
Range	68.5
Interquartile range (IQR)	0.4

Descriptive statistics

Standard deviation	4.654601236
Coefficient of variation (CV)	3.86500702
Kurtosis	109.6808753
Mean	1.204293087
Median Absolute Deviation (MAD)	0
Skewness	9.308247685
Sum	29174.00003
Variance	21.66531266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15969	65.9%
0.2	1252	5.2%
0.4	1052	4.3%
0.5	413	1.7%
1.2	386	1.6%
0.1	359	1.5%
1.4	346	1.4%
0.3	313	1.3%
3.8	297	1.2%
0.8	270	1.1%
Other values (257)	3568	14.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15969	65.9%
0.1	359	1.5%
0.2	1252	5.2%
0.3	313	1.3%
0.4	1052	4.3%
0.5	413	1.7%
0.6	53	0.2%
0.7	84	0.3%
0.8	270	1.1%
0.9	137	0.6%

Value	Count	Frequency (%)
68.5	1	< 0.1%
68.3	1	< 0.1%
68.1	1	< 0.1%
67.9	1	< 0.1%
67.8	1	< 0.1%
67.6	1	< 0.1%
67.4	1	< 0.1%
67.3	1	< 0.1%
67.2	1	< 0.1%
67.1	1	< 0.1%

Final Rainfall (mm)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	17
Distinct (%)	0.1%
Missing	7
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.007500515996

Minimum	0
Maximum	3.8
Zeros	23303
Zeros (%)	96.2%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3.8
Range	3.8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0554595147
Coefficient of variation (CV)	7.394093251
Kurtosis	1176.808331
Mean	0.007500515996
Median Absolute Deviation (MAD)	0
Skewness	24.17215341
Sum	181.7
Variance	0.003075757771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	23303	96.2%
0.1	468	1.9%
0.2	305	1.3%
0.4	57	0.2%
0.3	47	0.2%
0.6	19	0.1%
0.5	9	< 0.1%
0.7	5	< 0.1%
0.8	3	< 0.1%
1.2	2	< 0.1%
Other values (7)	7	< 0.1%
(Missing)	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	23303	96.2%
0.1	468	1.9%
0.2	305	1.3%
0.3	47	0.2%
0.4	57	0.2%
0.5	9	< 0.1%
0.6	19	0.1%
0.7	5	< 0.1%
0.8	3	< 0.1%
1	1	< 0.1%

Value	Count	Frequency (%)
3.8	1	< 0.1%
2.4	1	< 0.1%
1.8	1	< 0.1%
1.4	1	< 0.1%
1.3	1	< 0.1%
1.2	2	< 0.1%
1.1	1	< 0.1%
1	1	< 0.1%
0.8	3	< 0.1%
0.7	5	< 0.1%

MP1 FLOW1 (l/s)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	15742
Distinct (%)	78.6%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	2.914185005

Minimum	0
Maximum	66.66148
Zeros	4243
Zeros (%)	17.5%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.89527
median	2.022915
Q3	3.599202
95-th percentile	7.6190813
Maximum	66.66148
Range	66.66148
Interquartile range (IQR)	2.703932

Descriptive statistics

Standard deviation	4.996638831
Coefficient of variation (CV)	1.714592184
Kurtosis	74.41237956
Mean	2.914185005
Median Absolute Deviation (MAD)	1.373852
Skewness	7.701563242
Sum	58339.06961
Variance	24.96639961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4243	17.5%
1.965526	2	< 0.1%
3.354413	2	< 0.1%
3.427721	2	< 0.1%
3.15599	2	< 0.1%
1.900478	2	< 0.1%
2.735183	2	< 0.1%
4.365997	2	< 0.1%
4.004923	2	< 0.1%
3.227255	2	< 0.1%
Other values (15732)	15758	65.0%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4243	17.5%
0.122645	1	< 0.1%
0.143324	1	< 0.1%
0.208879	1	< 0.1%
0.246496	1	< 0.1%
0.363016	1	< 0.1%
0.41898	1	< 0.1%
0.425241	1	< 0.1%
0.432973	1	< 0.1%
0.434453	1	< 0.1%

Value	Count	Frequency (%)
66.66148	1	< 0.1%
66.61517	1	< 0.1%
65.48769	1	< 0.1%
65.31937	1	< 0.1%
64.44538	1	< 0.1%
64.30639	1	< 0.1%
64.23135	1	< 0.1%
64.13335	1	< 0.1%
64.05045	1	< 0.1%
64.03623	1	< 0.1%

MP1 PDEPTH_1 (mm)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	7263
Distinct (%)	36.3%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	65.82876317

Minimum	0
Maximum	2604.37
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	13.749
Q1	32.285
median	55.95
Q3	68
95-th percentile	82.891
Maximum	2604.37
Range	2604.37
Interquartile range (IQR)	35.715

Descriptive statistics

Standard deviation	159.8313451
Coefficient of variation (CV)	2.427986451
Kurtosis	151.2705633
Mean	65.82876317
Median Absolute Deviation (MAD)	16
Skewness	11.85758133
Sum	1317826.01
Variance	25546.05888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.73	16	0.1%
60.75	11	< 0.1%
61.97	11	< 0.1%
25.09	10	< 0.1%
52.8	10	< 0.1%
55.98	10	< 0.1%
58.08	10	< 0.1%
60.78	10	< 0.1%
62.17	10	< 0.1%
60.9	10	< 0.1%
Other values (7253)	19911	82.2%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
5.71	1	< 0.1%
5.89	1	< 0.1%
5.92	1	< 0.1%
6.15	1	< 0.1%
6.45	1	< 0.1%
6.46	1	< 0.1%
6.53	2	< 0.1%
6.57	1	< 0.1%
6.74	2	< 0.1%

Value	Count	Frequency (%)
2604.37	1	< 0.1%
2597.59	1	< 0.1%
2584.69	1	< 0.1%
2570.91	1	< 0.1%
2568.81	1	< 0.1%
2552.14	1	< 0.1%
2551.7	1	< 0.1%
2535.91	1	< 0.1%
2500.16	1	< 0.1%
2481.31	1	< 0.1%

MP1 UNIDEPTH (mm)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6008
Distinct (%)	30.0%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	67.89456616

Minimum	-253.75
Maximum	2604.37
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	189.4 KiB

Quantile statistics

Minimum	-253.75
5-th percentile	29.61
Q1	40.125
median	49.45
Q3	66.8
95-th percentile	87.303
Maximum	2604.37
Range	2858.12
Interquartile range (IQR)	26.675

Descriptive statistics

Standard deviation	159.2273028
Coefficient of variation (CV)	2.345214231
Kurtosis	153.0028371
Mean	67.89456616
Median Absolute Deviation (MAD)	13.29
Skewness	11.9573398
Sum	1359181.32
Variance	25353.33395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.23	36	0.1%
33.42	30	0.1%
37.72	25	0.1%
37.24	24	0.1%
33.43	23	0.1%
29.33	23	0.1%
28.94	22	0.1%
29.21	22	0.1%
29.22	21	0.1%
33.46	20	0.1%
Other values (5998)	19773	81.6%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-253.75	1	< 0.1%
12.16	1	< 0.1%
12.45	1	< 0.1%
12.68	1	< 0.1%
12.86	1	< 0.1%
12.91	1	< 0.1%
12.95	1	< 0.1%
13.02	1	< 0.1%
13.11	1	< 0.1%
13.27	1	< 0.1%

Value	Count	Frequency (%)
2604.37	1	< 0.1%
2597.59	1	< 0.1%
2584.69	1	< 0.1%
2570.91	1	< 0.1%
2568.81	1	< 0.1%
2552.14	1	< 0.1%
2551.7	1	< 0.1%
2535.91	1	< 0.1%
2500.16	1	< 0.1%
2481.31	1	< 0.1%

MP1 UpDEPTH_1 (mm)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5936
Distinct (%)	29.7%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	57.14219142

Minimum	-253.75
Maximum	435.06
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	189.4 KiB

Quantile statistics

Minimum	-253.75
5-th percentile	29.61
Q1	40.14
median	49.48
Q3	66.8
95-th percentile	87.303
Maximum	435.06
Range	688.81
Interquartile range (IQR)	26.66

Descriptive statistics

Standard deviation	40.5613617
Coefficient of variation (CV)	0.7098320995
Kurtosis	66.60256449
Mean	57.14219142
Median Absolute Deviation (MAD)	13.29
Skewness	7.451137369
Sum	1143929.53
Variance	1645.224063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.23	36	0.1%
33.42	30	0.1%
37.72	25	0.1%
37.24	24	0.1%
29.33	23	0.1%
33.43	23	0.1%
29.21	22	0.1%
28.94	22	0.1%
29.22	21	0.1%
33.47	20	0.1%
Other values (5926)	19773	81.6%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-253.75	1	< 0.1%
26.64	1	< 0.1%
26.78	1	< 0.1%
26.83	1	< 0.1%
26.94	1	< 0.1%
27.21	1	< 0.1%
27.28	1	< 0.1%
27.32	1	< 0.1%
27.41	2	< 0.1%
27.42	2	< 0.1%

Value	Count	Frequency (%)
435.06	1	< 0.1%
434.95	1	< 0.1%
434.77	1	< 0.1%
434.37	1	< 0.1%
434.27	1	< 0.1%
434.2	1	< 0.1%
434.19	1	< 0.1%
434.14	2	< 0.1%
434.13	1	< 0.1%
434.11	2	< 0.1%

MP1 WATERTEMP_1 (°C)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	112
Distinct (%)	0.6%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	15.20944103

Minimum	-17.8
Maximum	21.7
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	189.4 KiB

Quantile statistics

Minimum	-17.8
5-th percentile	11.9
Q1	13.5
median	14.8
Q3	16.2
95-th percentile	20
Maximum	21.7
Range	39.5
Interquartile range (IQR)	2.7

Descriptive statistics

Standard deviation	2.400659687
Coefficient of variation (CV)	0.1578400996
Kurtosis	1.440033536
Mean	15.20944103
Median Absolute Deviation (MAD)	1.4
Skewness	0.5494477607
Sum	304477.8
Variance	5.763166932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	554	2.3%
15.3	511	2.1%
14.6	501	2.1%
14.8	492	2.0%
14.3	469	1.9%
15	462	1.9%
14.1	449	1.9%
13.8	425	1.8%
13.6	409	1.7%
15.4	400	1.7%
Other values (102)	15347	63.3%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-17.8	1	< 0.1%
10.7	1	< 0.1%
10.8	15	0.1%
10.9	6	< 0.1%
11	20	0.1%
11.1	28	0.1%
11.2	16	0.1%
11.3	55	0.2%
11.4	62	0.3%
11.5	124	0.5%

Value	Count	Frequency (%)
21.7	3	< 0.1%
21.6	14	0.1%
21.5	14	0.1%
21.4	17	0.1%
21.3	25	0.1%
21.2	24	0.1%
21.1	31	0.1%
21	39	0.2%
20.9	34	0.1%
20.8	50	0.2%

Raw Average Velocity (m/s)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	775
Distinct (%)	3.9%
Missing	4213
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	0.2156684849

Minimum	0
Maximum	0.8586
Zeros	4243
Zeros (%)	17.5%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1251
median	0.2034
Q3	0.315
95-th percentile	0.477
Maximum	0.8586
Range	0.8586
Interquartile range (IQR)	0.1899

Descriptive statistics

Standard deviation	0.158926623
Coefficient of variation (CV)	0.7369023946
Kurtosis	0.2417926295
Mean	0.2156684849
Median Absolute Deviation (MAD)	0.0963
Skewness	0.5273468258
Sum	4317.4674
Variance	0.0252576715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4243	17.5%
0.198	82	0.3%
0.1953	82	0.3%
0.1899	80	0.3%
0.1962	79	0.3%
0.2043	79	0.3%
0.1998	77	0.3%
0.1647	77	0.3%
0.2061	75	0.3%
0.2052	75	0.3%
Other values (765)	15070	62.2%
(Missing)	4213	17.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4243	17.5%
0.0144	1	< 0.1%
0.018	1	< 0.1%
0.027	1	< 0.1%
0.0288	1	< 0.1%
0.0342	1	< 0.1%
0.0585	1	< 0.1%
0.0612	1	< 0.1%
0.063	2	< 0.1%
0.0684	1	< 0.1%

Value	Count	Frequency (%)
0.8586	1	< 0.1%
0.8559	1	< 0.1%
0.8478	1	< 0.1%
0.8451	1	< 0.1%
0.8424	1	< 0.1%
0.8406	1	< 0.1%
0.8388	1	< 0.1%
0.8379	1	< 0.1%
0.8352	1	< 0.1%
0.8334	1	< 0.1%

hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.32481842

Minimum	0
Maximum	23
Zeros	1078
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.97853455
Coefficient of variation (CV)	0.6162160213
Kurtosis	-1.216991132
Mean	11.32481842
Median Absolute Deviation (MAD)	6
Skewness	0.02507578135
Sum	274423
Variance	48.69994446
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
3	1115	4.6%
2	1099	4.5%
0	1078	4.4%
1	1073	4.4%
4	1056	4.4%
23	1047	4.3%
12	1034	4.3%
15	1013	4.2%
16	1013	4.2%
11	1005	4.1%
Other values (14)	13699	56.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1078	4.4%
1	1073	4.4%
2	1099	4.5%
3	1115	4.6%
4	1056	4.4%
5	1003	4.1%
6	983	4.1%
7	950	3.9%
8	953	3.9%
9	981	4.0%

Value	Count	Frequency (%)
23	1047	4.3%
22	970	4.0%
21	964	4.0%
20	945	3.9%
19	974	4.0%
18	988	4.1%
17	1000	4.1%
16	1013	4.2%
15	1013	4.2%
14	1002	4.1%

day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.83336085

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	15
Q3	22
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.371194035
Coefficient of variation (CV)	0.528706073
Kurtosis	-0.9126920805
Mean	15.83336085
Median Absolute Deviation (MAD)	6
Skewness	0.1132623796
Sum	383674
Variance	70.07688957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
16	1547	6.4%
15	1481	6.1%
13	1265	5.2%
17	1264	5.2%
14	1237	5.1%
12	1175	4.8%
30	916	3.8%
11	869	3.6%
18	865	3.6%
29	836	3.4%
Other values (21)	12777	52.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	670	2.8%
2	596	2.5%
3	582	2.4%
4	770	3.2%
5	801	3.3%
6	572	2.4%
7	793	3.3%
8	722	3.0%
9	432	1.8%
10	401	1.7%

Value	Count	Frequency (%)
31	609	2.5%
30	916	3.8%
29	836	3.4%
28	766	3.2%
27	626	2.6%
26	792	3.3%
25	510	2.1%
24	328	1.4%
23	508	2.1%
22	505	2.1%

month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.935622318

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	5
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.028550339
Coefficient of variation (CV)	0.6136106339
Kurtosis	-0.1306593407
Mean	4.935622318
Median Absolute Deviation (MAD)	2
Skewness	0.8625602216
Sum	119600
Variance	9.172117156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	6899	28.5%
4	4772	19.7%
2	4528	18.7%
10	2223	9.2%
1	2100	8.7%
12	1161	4.8%
9	1034	4.3%
7	629	2.6%
3	551	2.3%
11	257	1.1%
Other values (2)	78	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2100	8.7%
2	4528	18.7%
3	551	2.3%
4	4772	19.7%
5	6899	28.5%
6	57	0.2%
7	629	2.6%
8	21	0.1%
9	1034	4.3%
10	2223	9.2%

Value	Count	Frequency (%)
12	1161	4.8%
11	257	1.1%
10	2223	9.2%
9	1034	4.3%
8	21	0.1%
7	629	2.6%
6	57	0.2%
5	6899	28.5%
4	4772	19.7%
3	551	2.3%

date
Date

UNIQUE

Distinct	24232
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	189.4 KiB

Minimum	2018-12-31 01:20:00
Maximum	2021-06-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

targets
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	24232

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	24232	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	24232	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	MP1 FLOW1 (l/s)	MP1 PDEPTH_1 (mm)	MP1 UNIDEPTH (mm)	MP1 UpDEPTH_1 (mm)	MP1 WATERTEMP_1 (°C)	Raw Average Velocity (m/s)	hour	day	month	date	targets
0	16	2.421489	60.44	64.70	64.70	14.7	0.1710	1	31	12	2018-12-31 01:20:00	1
1	17	0.000000	60.58	64.48	64.48	14.7	0.0000	1	31	12	2018-12-31 01:25:00	1
2	18	2.088682	59.26	64.02	64.02	14.6	0.1503	1	31	12	2018-12-31 01:30:00	1
3	19	2.206280	58.65	63.62	63.62	14.6	0.1602	1	31	12	2018-12-31 01:35:00	1
4	20	2.307978	58.83	63.40	63.40	14.6	0.1683	1	31	12	2018-12-31 01:40:00	1
5	21	0.000000	58.79	63.20	63.20	14.5	0.0000	1	31	12	2018-12-31 01:45:00	1
6	22	2.704178	59.08	63.04	63.04	14.6	0.1980	1	31	12	2018-12-31 01:50:00	1
7	23	2.622683	59.35	62.98	62.98	14.5	0.1926	1	31	12	2018-12-31 01:55:00	1
8	24	2.527918	60.79	61.79	61.79	14.5	0.1908	2	31	12	2018-12-31 02:00:00	1
9	25	2.435273	60.77	62.00	62.00	14.4	0.1827	2	31	12	2018-12-31 02:05:00	1

Last rows

	df_index	MP1 FLOW1 (l/s)	MP1 PDEPTH_1 (mm)	MP1 UNIDEPTH (mm)	MP1 UpDEPTH_1 (mm)	MP1 WATERTEMP_1 (°C)	Raw Average Velocity (m/s)	hour	day	month	date	targets
24222	254302	0.00000	83.83	79.50	79.50	15.4	0.0000	23	31	5	2021-05-31 23:15:00	1
24223	254303	4.31069	85.13	79.43	79.43	15.3	0.2430	23	31	5	2021-05-31 23:20:00	1
24224	254304	0.00000	85.36	79.35	79.35	15.4	0.0000	23	31	5	2021-05-31 23:25:00	1
24225	254305	0.00000	84.30	79.19	79.19	15.4	0.0000	23	31	5	2021-05-31 23:30:00	1
24226	254306	0.00000	83.82	79.07	79.07	15.3	0.0000	23	31	5	2021-05-31 23:35:00	1
24227	254307	0.00000	83.92	78.88	78.88	15.3	0.0000	23	31	5	2021-05-31 23:40:00	1
24228	254308	0.00000	83.66	78.70	78.70	15.3	0.0000	23	31	5	2021-05-31 23:45:00	1
24229	254309	3.96669	83.75	78.65	78.65	15.3	0.2268	23	31	5	2021-05-31 23:50:00	1
24230	254310	0.00000	83.90	78.54	78.54	15.3	0.0000	23	31	5	2021-05-31 23:55:00	1
24231	254311	0.00000	82.96	78.44	78.44	15.2	0.0000	0	1	6	2021-06-01 00:00:00	1

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows